// 数据类型
const { DataTypes } = require('sequelize');

const seq = require('../db/seq');
const Goods = require('./goods.model');

// 定义cart模型
const Cart = seq.define('zd_carts', {
    goods_id: {
        type: DataTypes.INTEGER,
        allowNull: false,
        comment: '商品的id'
    },
    user_id: {
        type: DataTypes.INTEGER,
        allowNull: false,
        comment: '用户的id'
    },
    number: {
        type: DataTypes.INTEGER,
        allowNull: false,
        defaultValue: 1,
        comment: '商品数量'
    },
    selected: {
        type: DataTypes.BOOLEAN,
        allowNull: false,
        defaultValue: true,
        comment: "是否选中"
    },
})

// 同步数据表
// Cart.sync({ force: true })

// 关联数据表
Cart.belongsTo(Goods, {
    foreignKey: 'goods_id',// 外键
    as: 'goods_info',// 别名
})


module.exports = Cart